Senior BI Analyst (SQL Code)

Randstad is currently working with a Queensland Government Client to find an A06 level Senior BI Analyst (SQL Coder) for an initial 6 Months Fixed Term position. This role is based in Kedron with WFH flexibility.

This is a technical role which would require someone proficient in writing SQL code. The client also uses Cognos as their reporting platform and are undergoing a version upgrade so someone who also has Cognos experience would be great but not essential.

Key Responsibilities:
▪ Provide authoritative, expert, and timely technical advice on business intelligence solutions to inform the ongoing development and maturity of the client's enterprise suite of business intelligence tools.
▪ Undertake ongoing development, maintenance, and enhancement activities to optimise business intelligence systems and processes, including database design, Extract Transform and Load (ETL) and reporting to ensure high-quality business critical information is readily available to support operational decision making.
▪ Develop business intelligence tools including visualisations, dashboards, and suites of standard reports to support timely operational decision making.
▪ Actively participate in the identification and management of risks and issues regarding business intelligence solutions.
▪ Design, develop and deploy Online Analytical Processing (OLAP) cubes incorporating various data sources to enable consistent and timely access to self-service operational activity reporting.
▪ Design, develop, test, and release complex data extracts from large datasets using Structured Query Language (SQL) within Microsoft SQL Server and Oracle database technologies.
▪ Using a high-level knowledge of operations and business, analyse, interpret and transform complex data extracts into meaningful information, and present it in a professional manner to support operational performance reporting and decision making.
▪ Develop and maintain business intelligence and technical documentation including architectural diagrams, design documents, project quality plans, process mapping, technical specifications, report specifications and data dictionaries.


The ideal candidate will possess:

▪ Demonstrated high level knowledge and experience in the effective operation of a multi-tier business intelligence platform using enterprise level tools, including Oracle and Microsoft SQL Server Relational Database Management Systems (or similar).
▪ Demonstrated high level ability to develop, coordinate and implement complex data design, collection, interpretation, analysis and practical reporting solutions using business intelligence systems.
▪ Experience with SQL, T/SQL, PL/SQL, Cognos Transformer and Framework Manager is highly desirable.
▪ Experience with PowerBI or similar is highly desirable.
▪ Knowledge and experience in relational and dimensional data modelling methodologies is highly desirable.
▪ Experience in scripting languages (e.g. Python) is highly desirable.
▪ Whilst not mandatory, a Bachelor’s Degree in Information Systems/Computer Science and/or equivalent will be highly regarded.

At Randstad, we are passionate about providing equal employment opportunities and embracing diversity to the benefit of all. We actively encourage applications from any background.